Python GUI Programming Using Tkinter and SQLite3

Learn how an api connects a client to a kitchen backend via a waiter, using get and post requests to fetch or store data across multiple fronts.

Learn to access the CoinMarketCap API to retrieve market cap, price, and 24h changes, register a free plan, manage API keys, and query endpoints for Python Tkinter and SQLite projects.

Explore api format concepts by comparing beautified and minified json outputs. Learn to read and extract data using json formatters, and understand that formatting affects readability, not content.

We show how to fetch data from the EPA API using the requests module and parse it with json, then print the parsed results in a Python notebook.

Learn to extract specific api data, focusing on symbol and price, by navigating nested dictionaries and lists in crypto data responses, and apply these techniques to build a portfolio app.

Use for loops and range to build and format a five-coin portfolio, then match symbols to fetch and display each invested coin's price data for BTC and US.

Create a coin portfolio using dictionaries to track symbol, amount, and price, converting from a list to a dictionary and printing the coin name with its symbol.

Learn to calculate profit and loss for a coin portfolio in Python by tracking total amount paid, current value, and per-coin and total profits, with formatted outputs.

Explore graphical user interfaces in Python with tkinter and PyQt, import classes, and build simple apps like Notepad and a calculator for a crypto portfolio project.

Create a Tkinter instance, configure the window title and icon, build the GUI widgets, and start the main loop to display the application.

Create a Tkinter main window and labels, placing them with the grid geometry manager using row and column coordinates, then customize background colors.

Wrap the Tkinter GUI code in a function and add a header for seven columns, including coin name, current value, and profit and loss, to plan a portfolio design.

Build and enhance a Python GUI application using Tkinter and sqlite3, displaying coin data with labels across dynamic rows in a portfolio layout.

Enhance a tkinter-based Python app by refining the user interface with color schemes, typography, padding, borders, and icons, and implement dynamic profit, loss, and investment displays.

build a color-indication handler that returns green for positive amounts and red for negative, converting inputs to float and applying it to current value, profit and loss, and total profit and loss.

Learn to add an update button in a Python Tkinter and SQLite3 GUI that clears current data, calls a portfolio function, and refreshes profit and loss with fresh data.

Package your Python GUI project into a single emc file with PyInstaller, using a custom icon and bundled libraries for a portable, no-python-needed distribution.

Explore how databases organize data in tables with rows and columns, compare sql databases to sqlite3, and learn insert, fetch, update, and delete operations.

Explore sqlite3 basics by importing sqlite3, establishing a zero-configuration connection, creating a cursor, executing statements, and closing the connection to manage a database in Python.

Create an employees table via the cursor execute call, define id as integer primary key and fields name, salary, department, and position, then commit and inspect the DB browser.

Learn to insert values into a SQLite3 database using Python's cursor, including insert into table values and placeholders, handle auto-increment IDs, and outline dynamic insert, update, and delete functions.

Update an employee's department by their unique id, commit the changes, and prepare to retrieve data with select and fetch operations.

Learn how to fetch and display data from a SQLite database using Python, including selecting specific columns, applying where conditions, and using parameterized queries to prevent SQL injection.

Delete data from the database by executing a delete query with a condition to remove a specific row, or omit the condition to delete all records, then commit.

Define functions to create tables using create table if not exists, and to insert, update, delete, and fetch data in Python sqlite3 application, passing id, name, salary, department, and position.

Connect a Tkinter app to a SQLite database, create tables, and perform insert, fetch, and close the connection with commit on a coin table.

Fetch data from the coins table using a cursor, execute select star from coins, and iterate results to display symbols, amounts, and prices for a Tkinter SQLite3 app.

Fix issues and refactor code for proper format, add total amount paid and portfolio id column, refresh subject name, and plan insert, update, and delete operations for the portfolio database.